Previous Topic

Next Topic

Guidelines for Building Tables

While the number and types of data elements or fields that compose a table entry vary from table to table, they all contain two similar definition fields, the code and a longer description. The code is usually an all upper-case abbreviation that represents or corresponds to the longer table entry description. For example, in the table of states, the standard 2-character abbreviation (TX) is the code, and the state name (Texas) is the description.

The code is a critical field and is:

In most fields, iMIS only lets you enter or select a code that exists in a table entry definition. In a field referencing the STATE_PROVINCE table, for example, iMIS would reject the code "TT" as not being a valid table entry.

In assigning codes, follow these guidelines:

In This Section

Using table maintenance windows

See Also

Customer Table Maintenance

Table Maintenance Overview

iMIS Table Layout

Defining Customer Types

Setting up Committees

Setting up Chapter Management

Setting up Relationship Types


ASI logo 10.6 Production Release. Updated 1/18/2006 11:51:00 AM
© Copyright by Advanced Solutions International, Inc. All rights reserved.